USE [RD_SalesMart]
GO

/****** Object:  Index [PK_Sales_Star_PriceAdjustment]    Script Date: 02/21/2011 21:22:00 ******/
ALTER TABLE [dbo].[Sales_Star_PriceAdjustment] ADD  CONSTRAINT [PK_Sales_Star_PriceAdjustment] PRIMARY KEY CLUSTERED 
(
	[AdjustmentName] ASC,
	[ItemNumber] ASC,
	[AddressNumber] ASC,
	[CurrencyCode] ASC,
	[UnitOfMeasureAsInput] ASC,
	[QuantityFrom] ASC,
	[ExpiredDate] ASC,
	[DateUpdated] ASC,
	[TimeOfDay] ASC,
	[ItemGroupKeyID] ASC,
	[CustomerGroupKeyID] ASC,
	[OrderGroupKeyID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


USE [RD_SalesMart]
GO

/****** Object:  Index [missing_index_116]    Script Date: 02/21/2011 21:21:51 ******/
CREATE NONCLUSTERED INDEX [missing_index_116] ON [dbo].[Sales_Star_PriceAdjustment] 
(
	[PriceAdjustmentKeyID] ASC,
	[ExpiredDate] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_256]    Script Date: 02/21/2011 21:21:51 ******/
CREATE NONCLUSTERED INDEX [missing_index_256] ON [dbo].[Sales_Star_PriceAdjustment] 
(
	[ExpiredDate] ASC
)
INCLUDE ( [PriceAdjustmentKeyID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_674]    Script Date: 02/21/2011 21:21:51 ******/
CREATE NONCLUSTERED INDEX [missing_index_674] ON [dbo].[Sales_Star_PriceAdjustment] 
(
	[ExpiredDate] ASC
)
INCLUDE ( [SourceID],
[Source],
[AdjustmentName],
[ItemNumber],
[ItemNumber02],
[ItemNumber03],
[AddressNumber],
[ItemCustomerKeyID],
[OrderDetailGroup],
[SalesDetailValue01],
[SalesDetailValue02],
[SalesDetailValue03],
[CurrencyCode],
[UnitOfMeasureAsInput],
[QuantityFrom],
[EffectiveDate],
[Basis],
[CostMethodCode],
[FormulaName],
[FactorValue],
[FreeGoods],
[PriceAdjustmentKeyID],
[UserReservedCode],
[UserReservedDate],
[UserReservedAmount],
[UserReservedNumber],
[UserReservedReference],
[UserID],
[ProgramID],
[WorkStationID],
[DateUpdated],
[TimeOfDay],
[ItemGroupKeyID],
[CustomerGroupKeyID],
[OrderGroupKeyID],
[NumberofOrders],
[UnitofMeasureVolumeIncentives],
[FactorValueUnitofMeasure],
[PricePartialQuantitesFlag],
[ApprovalStatus],
[BasketParentID],
[CurrencyCodeVolumeIncentives],
[RoundingRuleName],
[InsertIndicator],
[InsertDate],
[ChangeIndicator],
[ChangeDate],
[DeleteIndicator],
[DeleteDate],
[PurgeDate],
[OrderDetailGroupOGKM],
[SalesDetailValueOGKM01],
[SalesDetailValueOGKM02],
[SalesDetailValueOGKM03],
[SalesDetailValueOGKM04],
[SalesDetailValueOGKM05],
[SalesDetailValueOGKM06],
[SalesDetailValueOGKM07],
[SalesDetailValueOGKM08],
[OrderGroupKeyIDOGKM]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


